﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkCustomerRegister" targetNamespace="http://tempuri.org/CDmDjkCustomerRegister.xsd" xmlns:mstns="http://tempuri.org/CDmDjkCustomerRegister.xsd" xmlns="http://tempuri.org/CDmDjkCustomerRegister.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_CUSTOMER_REGISTERTableAdapter" GeneratorDataComponentClassName="DJK_CUSTOMER_REGISTERTableAdapter" Name="DJK_CUSTOMER_REGISTER" UserDataComponentName="DJK_CUSTOMER_REGISTERTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_CUSTOMER_REGISTER" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_CUSTOMER_REGISTER] WHERE (([CUSTOMER_REGISTER_ID] = @Original_CUSTOMER_REGISTER_ID) AND ([CUSTOMER_REGISTER_ACCOUNT] = @Original_CUSTOMER_REGISTER_ACCOUNT) AND ((@IsNull_CUSTOMER_REGISTER_PWD = 1 AND [CUSTOMER_REGISTER_PWD] IS NULL) OR ([CUSTOMER_REGISTER_PWD] = @Original_CUSTOMER_REGISTER_PWD)) AND ([CUSTOMER_REGISTER_TIME] = @Original_CUSTOMER_REGISTER_TIME) AND ([CUSTOMER_ACCOUNT_TYPE] = @Original_CUSTOMER_ACCOUNT_TYPE) AND ((@IsNull_CUSTOMER_NICK = 1 AND [CUSTOMER_NICK] IS NULL) OR ([CUSTOMER_NICK] = @Original_CUSTOMER_NICK)) AND ((@IsNull_CUSTOMER_CLIENT_CODE = 1 AND [CUSTOMER_CLIENT_CODE] IS NULL) OR ([CUSTOMER_CLIENT_CODE] = @Original_CUSTOMER_CLIENT_CODE)) AND ([ACCOUNT_USING_STATUS] = @Original_ACCOUNT_USING_STATUS) AND ([ACCOUNT_LOGIN_STATUS] = @Original_ACCOUNT_LOGIN_STATUS) AND ((@IsNull_CUSTOMER_DEFAULT_PIC = 1 AND [CUSTOMER_DEFAULT_PIC] IS NULL) OR ([CUSTOMER_DEFAULT_PIC] = @Original_CUSTOMER_DEFAULT_PIC)) AND ((@IsNull_CUSTOMER_SOURCE_PIC = 1 AND [CUSTOMER_SOURCE_PIC] IS NULL) OR ([CUSTOMER_SOURCE_PIC] = @Original_CUSTOMER_SOURCE_PIC)) AND ((@IsNull_ACCOUNT_ACTIVATION_CODE = 1 AND [ACCOUNT_ACTIVATION_CODE] IS NULL) OR ([ACCOUNT_ACTIVATION_CODE] = @Original_ACCOUNT_ACTIVATION_CODE)) AND ([ACCOUNT_IS_ACTIVATED] = @Original_ACCOUNT_IS_ACTIVATED) AND ((@IsNull_BE_INVITATION_CODE = 1 AND [BE_INVITATION_CODE] IS NULL) OR ([BE_INVITATION_CODE] = @Original_BE_INVITATION_CODE)) AND ((@IsNull_CUSTOMER_INVITATION_CODE = 1 AND [CUSTOMER_INVITATION_CODE] IS NULL) OR ([CUSTOMER_INVITATION_CODE] = @Original_CUSTOMER_INVITATION_CODE)) AND ((@IsNull_ACCOUNT_REGISTER_IP = 1 AND [ACCOUNT_REGISTER_IP] IS NULL) OR ([ACCOUNT_REGISTER_IP] = @Original_ACCOUNT_REGISTER_IP)) AND ([ACCOUNT_IS_DELETED] = @Original_ACCOUNT_IS_DELETED) AND ((@IsNull_CUSTOMER_ACCOUNT_RMK = 1 AND [CUSTOMER_ACCOUNT_RMK] IS NULL) OR ([CUSTOMER_ACCOUNT_RMK] = @Original_CUSTOMER_ACCOUNT_RMK)) AND ((@IsNull_INITIAL_DT = 1 AND [INITIAL_DT] IS NULL) OR ([INITIAL_DT] = @Original_INITIAL_DT)) AND ((@IsNull_INITIAL_USR = 1 AND [INITIAL_USR] IS NULL) OR ([INITIAL_USR] = @Original_INITIAL_USR)) AND ((@IsNull_CUSTOMER_PAY_INNERPWD = 1 AND [CUSTOMER_PAY_INNERPWD] IS NULL) OR ([CUSTOMER_PAY_INNERPWD] = @Original_CUSTOMER_PAY_INNERPWD)) AND ((@IsNull_CUSTOMER_SET_INNERPWDDT = 1 AND [CUSTOMER_SET_INNERPWDDT] IS NULL) OR ([CUSTOMER_SET_INNERPWDDT] = @Original_CUSTOMER_SET_INNERPWDDT)) AND ((@IsNull_CUSTOMER_LAST_MDINNERPWDDT = 1 AND [CUSTOMER_LAST_MDINNERPWDDT] IS NULL) OR ([CUSTOMER_LAST_MDINNERPWDDT] = @Original_CUSTOMER_LAST_MDINNERPWDDT)) AND ((@IsNull_REG_VALID_CODE = 1 AND [REG_VALID_CODE] IS NULL) OR ([REG_VALID_CODE] = @Original_REG_VALID_CODE)) AND ((@IsNull_VALID_CREATE_DT = 1 AND [VALID_CREATE_DT] IS NULL) OR ([VALID_CREATE_DT] = @Original_VALID_CREATE_DT)) AND ((@IsNull_PWD_IS_MODIFIED = 1 AND [PWD_IS_MODIFIED] IS NULL) OR ([PWD_IS_MODIFIED] = @Original_PWD_IS_MODIFIED)) AND ((@IsNull_FIRST_USE_DT = 1 AND [FIRST_USE_DT] IS NULL) OR ([FIRST_USE_DT] = @Original_FIRST_USE_DT)) AND ((@IsNull_FACCOUNT_ID = 1 AND [FACCOUNT_ID] IS NULL) OR ([FACCOUNT_ID] = @Original_FACCOUNT_ID)) AND ((@IsNull_ACCOUNT_GROUP_ID = 1 AND [ACCOUNT_GROUP_ID] IS NULL) OR ([ACCOUNT_GROUP_ID] = @Original_ACCOUNT_GROUP_ID)) AND ((@IsNull_REGISTER_BY_INNER = 1 AND [REGISTER_BY_INNER] IS NULL) OR ([REGISTER_BY_INNER] = @Original_REGISTER_BY_INNER)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_REGISTER_PWD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_PWD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_PWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_PWD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_NICK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_NICK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_NICK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_NICK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CLIENT_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CLIENT_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_CLIENT_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CLIENT_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCOUNT_USING_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_USING_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCOUNT_LOGIN_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_LOGIN_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_DEFAULT_PIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_DEFAULT_PIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_DEFAULT_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DEFAULT_PIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SOURCE_PIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SOURCE_PIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_SOURCE_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SOURCE_PIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_ACTIVATION_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_ACTIVATION_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_ACTIVATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_ACTIVATION_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCOUNT_IS_ACTIVATED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_ACTIVATED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BE_INVITATION_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BE_INVITATION_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BE_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BE_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_INVITATION_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_INVITATION_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_REGISTER_IP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_REGISTER_IP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_REGISTER_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_REGISTER_IP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCOUNT_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_ACCOUNT_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_ACCOUNT_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_USR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SET_INNERPWDDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SET_INNERPWDDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_SET_INNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_SET_INNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_MDINNERPWDDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_MDINNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REG_VALID_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REG_VALID_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REG_VALID_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REG_VALID_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALID_CREATE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALID_CREATE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_VALID_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VALID_CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PWD_IS_MODIFIED" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PWD_IS_MODIFIED" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PWD_IS_MODIFIED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PWD_IS_MODIFIED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FIRST_USE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIRST_USE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FIRST_USE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FIRST_USE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FACCOUNT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FACCOUNT_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FACCOUNT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FACCOUNT_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_GROUP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_GROUP_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_GROUP_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_GROUP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REGISTER_BY_INNER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REGISTER_BY_INNER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REGISTER_BY_INNER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REGISTER_BY_INNER" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_CUSTOMER_REGISTER] ([CUSTOMER_REGISTER_ID], [CUSTOMER_REGISTER_ACCOUNT], [CUSTOMER_REGISTER_PWD], [CUSTOMER_REGISTER_TIME], [CUSTOMER_ACCOUNT_TYPE], [CUSTOMER_NICK], [CUSTOMER_CLIENT_CODE], [ACCOUNT_USING_STATUS], [ACCOUNT_LOGIN_STATUS], [CUSTOMER_DEFAULT_PIC], [CUSTOMER_SOURCE_PIC], [ACCOUNT_ACTIVATION_CODE], [ACCOUNT_IS_ACTIVATED], [BE_INVITATION_CODE], [CUSTOMER_INVITATION_CODE], [ACCOUNT_REGISTER_IP], [ACCOUNT_IS_DELETED], [CUSTOMER_ACCOUNT_RMK], [INITIAL_DT], [INITIAL_USR], [CUSTOMER_PAY_INNERPWD], [CUSTOMER_SET_INNERPWDDT], [CUSTOMER_LAST_MDINNERPWDDT], [REG_VALID_CODE], [VALID_CREATE_DT], [PWD_IS_MODIFIED], [FIRST_USE_DT], [FACCOUNT_ID], [ACCOUNT_GROUP_ID], [REGISTER_BY_INNER]) VALUES (@CUSTOMER_REGISTER_ID, @CUSTOMER_REGISTER_ACCOUNT, @CUSTOMER_REGISTER_PWD, @CUSTOMER_REGISTER_TIME, @CUSTOMER_ACCOUNT_TYPE, @CUSTOMER_NICK, @CUSTOMER_CLIENT_CODE, @ACCOUNT_USING_STATUS, @ACCOUNT_LOGIN_STATUS, @CUSTOMER_DEFAULT_PIC, @CUSTOMER_SOURCE_PIC, @ACCOUNT_ACTIVATION_CODE, @ACCOUNT_IS_ACTIVATED, @BE_INVITATION_CODE, @CUSTOMER_INVITATION_CODE, @ACCOUNT_REGISTER_IP, @ACCOUNT_IS_DELETED, @CUSTOMER_ACCOUNT_RMK, @INITIAL_DT, @INITIAL_USR, @CUSTOMER_PAY_INNERPWD, @CUSTOMER_SET_INNERPWDDT, @CUSTOMER_LAST_MDINNERPWDDT, @REG_VALID_CODE, @VALID_CREATE_DT, @PWD_IS_MODIFIED, @FIRST_USE_DT, @FACCOUNT_ID, @ACCOUNT_GROUP_ID, @REGISTER_BY_INNER);
SELECT CUSTOMER_REGISTER_ID, CUSTOMER_REGISTER_ACCOUNT, CUSTOMER_REGISTER_PWD, CUSTOMER_REGISTER_TIME, CUSTOMER_ACCOUNT_TYPE, CUSTOMER_NICK, CUSTOMER_CLIENT_CODE, ACCOUNT_USING_STATUS, ACCOUNT_LOGIN_STATUS, CUSTOMER_DEFAULT_PIC, CUSTOMER_SOURCE_PIC, ACCOUNT_ACTIVATION_CODE, ACCOUNT_IS_ACTIVATED, BE_INVITATION_CODE, CUSTOMER_INVITATION_CODE, ACCOUNT_REGISTER_IP, ACCOUNT_IS_DELETED, CUSTOMER_ACCOUNT_RMK, INITIAL_DT, INITIAL_USR, CUSTOMER_PAY_INNERPWD, CUSTOMER_SET_INNERPWDDT, CUSTOMER_LAST_MDINNERPWDDT, REG_VALID_CODE, VALID_CREATE_DT, PWD_IS_MODIFIED, FIRST_USE_DT, FACCOUNT_ID, ACCOUNT_GROUP_ID, REGISTER_BY_INNER FROM DJK_CUSTOMER_REGISTER WHERE (CUSTOMER_REGISTER_ID = @CUSTOMER_REGISTER_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_REGISTER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_REGISTER_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_REGISTER_PWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_PWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_REGISTER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_NICK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_NICK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_CLIENT_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CLIENT_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCOUNT_USING_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_USING_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCOUNT_LOGIN_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_LOGIN_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_DEFAULT_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DEFAULT_PIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_SOURCE_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SOURCE_PIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_ACTIVATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_ACTIVATION_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCOUNT_IS_ACTIVATED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_ACTIVATED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BE_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BE_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_REGISTER_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_REGISTER_IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCOUNT_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_ACCOUNT_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_SET_INNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_SET_INNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_MDINNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REG_VALID_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REG_VALID_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@VALID_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VALID_CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PWD_IS_MODIFIED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PWD_IS_MODIFIED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FIRST_USE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FIRST_USE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FACCOUNT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FACCOUNT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_GROUP_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_GROUP_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REGISTER_BY_INNER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REGISTER_BY_INNER" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CUSTOMER_REGISTER_ID, CUSTOMER_REGISTER_ACCOUNT, CUSTOMER_REGISTER_PWD, CUSTOMER_REGISTER_TIME, CUSTOMER_ACCOUNT_TYPE, CUSTOMER_NICK, CUSTOMER_CLIENT_CODE, ACCOUNT_USING_STATUS, ACCOUNT_LOGIN_STATUS, CUSTOMER_DEFAULT_PIC, CUSTOMER_SOURCE_PIC, ACCOUNT_ACTIVATION_CODE, ACCOUNT_IS_ACTIVATED, BE_INVITATION_CODE, CUSTOMER_INVITATION_CODE, ACCOUNT_REGISTER_IP, ACCOUNT_IS_DELETED, CUSTOMER_ACCOUNT_RMK, INITIAL_DT, INITIAL_USR, CUSTOMER_PAY_INNERPWD, CUSTOMER_SET_INNERPWDDT, CUSTOMER_LAST_MDINNERPWDDT, REG_VALID_CODE, VALID_CREATE_DT, PWD_IS_MODIFIED, FIRST_USE_DT, FACCOUNT_ID, ACCOUNT_GROUP_ID, REGISTER_BY_INNER FROM dbo.DJK_CUSTOMER_REGISTER</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_CUSTOMER_REGISTER] SET [CUSTOMER_REGISTER_ID] = @CUSTOMER_REGISTER_ID, [CUSTOMER_REGISTER_ACCOUNT] = @CUSTOMER_REGISTER_ACCOUNT, [CUSTOMER_REGISTER_PWD] = @CUSTOMER_REGISTER_PWD, [CUSTOMER_REGISTER_TIME] = @CUSTOMER_REGISTER_TIME, [CUSTOMER_ACCOUNT_TYPE] = @CUSTOMER_ACCOUNT_TYPE, [CUSTOMER_NICK] = @CUSTOMER_NICK, [CUSTOMER_CLIENT_CODE] = @CUSTOMER_CLIENT_CODE, [ACCOUNT_USING_STATUS] = @ACCOUNT_USING_STATUS, [ACCOUNT_LOGIN_STATUS] = @ACCOUNT_LOGIN_STATUS, [CUSTOMER_DEFAULT_PIC] = @CUSTOMER_DEFAULT_PIC, [CUSTOMER_SOURCE_PIC] = @CUSTOMER_SOURCE_PIC, [ACCOUNT_ACTIVATION_CODE] = @ACCOUNT_ACTIVATION_CODE, [ACCOUNT_IS_ACTIVATED] = @ACCOUNT_IS_ACTIVATED, [BE_INVITATION_CODE] = @BE_INVITATION_CODE, [CUSTOMER_INVITATION_CODE] = @CUSTOMER_INVITATION_CODE, [ACCOUNT_REGISTER_IP] = @ACCOUNT_REGISTER_IP, [ACCOUNT_IS_DELETED] = @ACCOUNT_IS_DELETED, [CUSTOMER_ACCOUNT_RMK] = @CUSTOMER_ACCOUNT_RMK, [INITIAL_DT] = @INITIAL_DT, [INITIAL_USR] = @INITIAL_USR, [CUSTOMER_PAY_INNERPWD] = @CUSTOMER_PAY_INNERPWD, [CUSTOMER_SET_INNERPWDDT] = @CUSTOMER_SET_INNERPWDDT, [CUSTOMER_LAST_MDINNERPWDDT] = @CUSTOMER_LAST_MDINNERPWDDT, [REG_VALID_CODE] = @REG_VALID_CODE, [VALID_CREATE_DT] = @VALID_CREATE_DT, [PWD_IS_MODIFIED] = @PWD_IS_MODIFIED, [FIRST_USE_DT] = @FIRST_USE_DT, [FACCOUNT_ID] = @FACCOUNT_ID, [ACCOUNT_GROUP_ID] = @ACCOUNT_GROUP_ID, [REGISTER_BY_INNER] = @REGISTER_BY_INNER WHERE (([CUSTOMER_REGISTER_ID] = @Original_CUSTOMER_REGISTER_ID) AND ([CUSTOMER_REGISTER_ACCOUNT] = @Original_CUSTOMER_REGISTER_ACCOUNT) AND ((@IsNull_CUSTOMER_REGISTER_PWD = 1 AND [CUSTOMER_REGISTER_PWD] IS NULL) OR ([CUSTOMER_REGISTER_PWD] = @Original_CUSTOMER_REGISTER_PWD)) AND ([CUSTOMER_REGISTER_TIME] = @Original_CUSTOMER_REGISTER_TIME) AND ([CUSTOMER_ACCOUNT_TYPE] = @Original_CUSTOMER_ACCOUNT_TYPE) AND ((@IsNull_CUSTOMER_NICK = 1 AND [CUSTOMER_NICK] IS NULL) OR ([CUSTOMER_NICK] = @Original_CUSTOMER_NICK)) AND ((@IsNull_CUSTOMER_CLIENT_CODE = 1 AND [CUSTOMER_CLIENT_CODE] IS NULL) OR ([CUSTOMER_CLIENT_CODE] = @Original_CUSTOMER_CLIENT_CODE)) AND ([ACCOUNT_USING_STATUS] = @Original_ACCOUNT_USING_STATUS) AND ([ACCOUNT_LOGIN_STATUS] = @Original_ACCOUNT_LOGIN_STATUS) AND ((@IsNull_CUSTOMER_DEFAULT_PIC = 1 AND [CUSTOMER_DEFAULT_PIC] IS NULL) OR ([CUSTOMER_DEFAULT_PIC] = @Original_CUSTOMER_DEFAULT_PIC)) AND ((@IsNull_CUSTOMER_SOURCE_PIC = 1 AND [CUSTOMER_SOURCE_PIC] IS NULL) OR ([CUSTOMER_SOURCE_PIC] = @Original_CUSTOMER_SOURCE_PIC)) AND ((@IsNull_ACCOUNT_ACTIVATION_CODE = 1 AND [ACCOUNT_ACTIVATION_CODE] IS NULL) OR ([ACCOUNT_ACTIVATION_CODE] = @Original_ACCOUNT_ACTIVATION_CODE)) AND ([ACCOUNT_IS_ACTIVATED] = @Original_ACCOUNT_IS_ACTIVATED) AND ((@IsNull_BE_INVITATION_CODE = 1 AND [BE_INVITATION_CODE] IS NULL) OR ([BE_INVITATION_CODE] = @Original_BE_INVITATION_CODE)) AND ((@IsNull_CUSTOMER_INVITATION_CODE = 1 AND [CUSTOMER_INVITATION_CODE] IS NULL) OR ([CUSTOMER_INVITATION_CODE] = @Original_CUSTOMER_INVITATION_CODE)) AND ((@IsNull_ACCOUNT_REGISTER_IP = 1 AND [ACCOUNT_REGISTER_IP] IS NULL) OR ([ACCOUNT_REGISTER_IP] = @Original_ACCOUNT_REGISTER_IP)) AND ([ACCOUNT_IS_DELETED] = @Original_ACCOUNT_IS_DELETED) AND ((@IsNull_CUSTOMER_ACCOUNT_RMK = 1 AND [CUSTOMER_ACCOUNT_RMK] IS NULL) OR ([CUSTOMER_ACCOUNT_RMK] = @Original_CUSTOMER_ACCOUNT_RMK)) AND ((@IsNull_INITIAL_DT = 1 AND [INITIAL_DT] IS NULL) OR ([INITIAL_DT] = @Original_INITIAL_DT)) AND ((@IsNull_INITIAL_USR = 1 AND [INITIAL_USR] IS NULL) OR ([INITIAL_USR] = @Original_INITIAL_USR)) AND ((@IsNull_CUSTOMER_PAY_INNERPWD = 1 AND [CUSTOMER_PAY_INNERPWD] IS NULL) OR ([CUSTOMER_PAY_INNERPWD] = @Original_CUSTOMER_PAY_INNERPWD)) AND ((@IsNull_CUSTOMER_SET_INNERPWDDT = 1 AND [CUSTOMER_SET_INNERPWDDT] IS NULL) OR ([CUSTOMER_SET_INNERPWDDT] = @Original_CUSTOMER_SET_INNERPWDDT)) AND ((@IsNull_CUSTOMER_LAST_MDINNERPWDDT = 1 AND [CUSTOMER_LAST_MDINNERPWDDT] IS NULL) OR ([CUSTOMER_LAST_MDINNERPWDDT] = @Original_CUSTOMER_LAST_MDINNERPWDDT)) AND ((@IsNull_REG_VALID_CODE = 1 AND [REG_VALID_CODE] IS NULL) OR ([REG_VALID_CODE] = @Original_REG_VALID_CODE)) AND ((@IsNull_VALID_CREATE_DT = 1 AND [VALID_CREATE_DT] IS NULL) OR ([VALID_CREATE_DT] = @Original_VALID_CREATE_DT)) AND ((@IsNull_PWD_IS_MODIFIED = 1 AND [PWD_IS_MODIFIED] IS NULL) OR ([PWD_IS_MODIFIED] = @Original_PWD_IS_MODIFIED)) AND ((@IsNull_FIRST_USE_DT = 1 AND [FIRST_USE_DT] IS NULL) OR ([FIRST_USE_DT] = @Original_FIRST_USE_DT)) AND ((@IsNull_FACCOUNT_ID = 1 AND [FACCOUNT_ID] IS NULL) OR ([FACCOUNT_ID] = @Original_FACCOUNT_ID)) AND ((@IsNull_ACCOUNT_GROUP_ID = 1 AND [ACCOUNT_GROUP_ID] IS NULL) OR ([ACCOUNT_GROUP_ID] = @Original_ACCOUNT_GROUP_ID)) AND ((@IsNull_REGISTER_BY_INNER = 1 AND [REGISTER_BY_INNER] IS NULL) OR ([REGISTER_BY_INNER] = @Original_REGISTER_BY_INNER)));
SELECT CUSTOMER_REGISTER_ID, CUSTOMER_REGISTER_ACCOUNT, CUSTOMER_REGISTER_PWD, CUSTOMER_REGISTER_TIME, CUSTOMER_ACCOUNT_TYPE, CUSTOMER_NICK, CUSTOMER_CLIENT_CODE, ACCOUNT_USING_STATUS, ACCOUNT_LOGIN_STATUS, CUSTOMER_DEFAULT_PIC, CUSTOMER_SOURCE_PIC, ACCOUNT_ACTIVATION_CODE, ACCOUNT_IS_ACTIVATED, BE_INVITATION_CODE, CUSTOMER_INVITATION_CODE, ACCOUNT_REGISTER_IP, ACCOUNT_IS_DELETED, CUSTOMER_ACCOUNT_RMK, INITIAL_DT, INITIAL_USR, CUSTOMER_PAY_INNERPWD, CUSTOMER_SET_INNERPWDDT, CUSTOMER_LAST_MDINNERPWDDT, REG_VALID_CODE, VALID_CREATE_DT, PWD_IS_MODIFIED, FIRST_USE_DT, FACCOUNT_ID, ACCOUNT_GROUP_ID, REGISTER_BY_INNER FROM DJK_CUSTOMER_REGISTER WHERE (CUSTOMER_REGISTER_ID = @CUSTOMER_REGISTER_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_REGISTER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_REGISTER_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_REGISTER_PWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_PWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_REGISTER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_NICK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_NICK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_CLIENT_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CLIENT_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCOUNT_USING_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_USING_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCOUNT_LOGIN_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_LOGIN_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_DEFAULT_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DEFAULT_PIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_SOURCE_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SOURCE_PIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_ACTIVATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_ACTIVATION_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCOUNT_IS_ACTIVATED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_ACTIVATED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BE_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BE_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_REGISTER_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_REGISTER_IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCOUNT_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_ACCOUNT_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_SET_INNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_SET_INNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_MDINNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REG_VALID_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REG_VALID_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@VALID_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VALID_CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PWD_IS_MODIFIED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PWD_IS_MODIFIED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FIRST_USE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FIRST_USE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FACCOUNT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FACCOUNT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_GROUP_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_GROUP_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REGISTER_BY_INNER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REGISTER_BY_INNER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_REGISTER_PWD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_PWD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_PWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_PWD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_REGISTER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_REGISTER_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_NICK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_NICK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_NICK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_NICK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CLIENT_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CLIENT_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_CLIENT_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CLIENT_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCOUNT_USING_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_USING_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCOUNT_LOGIN_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_LOGIN_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_DEFAULT_PIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_DEFAULT_PIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_DEFAULT_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DEFAULT_PIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SOURCE_PIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SOURCE_PIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_SOURCE_PIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SOURCE_PIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_ACTIVATION_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_ACTIVATION_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_ACTIVATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_ACTIVATION_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCOUNT_IS_ACTIVATED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_ACTIVATED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BE_INVITATION_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BE_INVITATION_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BE_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BE_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_INVITATION_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_INVITATION_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_INVITATION_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_INVITATION_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_REGISTER_IP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_REGISTER_IP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_REGISTER_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_REGISTER_IP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCOUNT_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCOUNT_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_ACCOUNT_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_ACCOUNT_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_USR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SET_INNERPWDDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SET_INNERPWDDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_SET_INNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_SET_INNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_MDINNERPWDDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_MDINNERPWDDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REG_VALID_CODE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REG_VALID_CODE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REG_VALID_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REG_VALID_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALID_CREATE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALID_CREATE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_VALID_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VALID_CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PWD_IS_MODIFIED" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PWD_IS_MODIFIED" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PWD_IS_MODIFIED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PWD_IS_MODIFIED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FIRST_USE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIRST_USE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FIRST_USE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FIRST_USE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FACCOUNT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FACCOUNT_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FACCOUNT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FACCOUNT_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_GROUP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_GROUP_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_GROUP_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_GROUP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REGISTER_BY_INNER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REGISTER_BY_INNER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REGISTER_BY_INNER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REGISTER_BY_INNER" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CUSTOMER_REGISTER_ID" DataSetColumn="CUSTOMER_REGISTER_ID" />
              <Mapping SourceColumn="CUSTOMER_REGISTER_ACCOUNT" DataSetColumn="CUSTOMER_REGISTER_ACCOUNT" />
              <Mapping SourceColumn="CUSTOMER_REGISTER_PWD" DataSetColumn="CUSTOMER_REGISTER_PWD" />
              <Mapping SourceColumn="CUSTOMER_REGISTER_TIME" DataSetColumn="CUSTOMER_REGISTER_TIME" />
              <Mapping SourceColumn="CUSTOMER_ACCOUNT_TYPE" DataSetColumn="CUSTOMER_ACCOUNT_TYPE" />
              <Mapping SourceColumn="CUSTOMER_NICK" DataSetColumn="CUSTOMER_NICK" />
              <Mapping SourceColumn="CUSTOMER_CLIENT_CODE" DataSetColumn="CUSTOMER_CLIENT_CODE" />
              <Mapping SourceColumn="ACCOUNT_USING_STATUS" DataSetColumn="ACCOUNT_USING_STATUS" />
              <Mapping SourceColumn="ACCOUNT_LOGIN_STATUS" DataSetColumn="ACCOUNT_LOGIN_STATUS" />
              <Mapping SourceColumn="CUSTOMER_DEFAULT_PIC" DataSetColumn="CUSTOMER_DEFAULT_PIC" />
              <Mapping SourceColumn="CUSTOMER_SOURCE_PIC" DataSetColumn="CUSTOMER_SOURCE_PIC" />
              <Mapping SourceColumn="ACCOUNT_ACTIVATION_CODE" DataSetColumn="ACCOUNT_ACTIVATION_CODE" />
              <Mapping SourceColumn="ACCOUNT_IS_ACTIVATED" DataSetColumn="ACCOUNT_IS_ACTIVATED" />
              <Mapping SourceColumn="BE_INVITATION_CODE" DataSetColumn="BE_INVITATION_CODE" />
              <Mapping SourceColumn="CUSTOMER_INVITATION_CODE" DataSetColumn="CUSTOMER_INVITATION_CODE" />
              <Mapping SourceColumn="ACCOUNT_REGISTER_IP" DataSetColumn="ACCOUNT_REGISTER_IP" />
              <Mapping SourceColumn="ACCOUNT_IS_DELETED" DataSetColumn="ACCOUNT_IS_DELETED" />
              <Mapping SourceColumn="CUSTOMER_ACCOUNT_RMK" DataSetColumn="CUSTOMER_ACCOUNT_RMK" />
              <Mapping SourceColumn="INITIAL_DT" DataSetColumn="INITIAL_DT" />
              <Mapping SourceColumn="INITIAL_USR" DataSetColumn="INITIAL_USR" />
              <Mapping SourceColumn="CUSTOMER_PAY_INNERPWD" DataSetColumn="CUSTOMER_PAY_INNERPWD" />
              <Mapping SourceColumn="CUSTOMER_SET_INNERPWDDT" DataSetColumn="CUSTOMER_SET_INNERPWDDT" />
              <Mapping SourceColumn="CUSTOMER_LAST_MDINNERPWDDT" DataSetColumn="CUSTOMER_LAST_MDINNERPWDDT" />
              <Mapping SourceColumn="REG_VALID_CODE" DataSetColumn="REG_VALID_CODE" />
              <Mapping SourceColumn="VALID_CREATE_DT" DataSetColumn="VALID_CREATE_DT" />
              <Mapping SourceColumn="PWD_IS_MODIFIED" DataSetColumn="PWD_IS_MODIFIED" />
              <Mapping SourceColumn="FIRST_USE_DT" DataSetColumn="FIRST_USE_DT" />
              <Mapping SourceColumn="FACCOUNT_ID" DataSetColumn="FACCOUNT_ID" />
              <Mapping SourceColumn="ACCOUNT_GROUP_ID" DataSetColumn="ACCOUNT_GROUP_ID" />
              <Mapping SourceColumn="REGISTER_BY_INNER" DataSetColumn="REGISTER_BY_INNER" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkCustomerRegister" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkCustomerRegister" msprop:Generator_UserDSName="CDmDjkCustomerRegister">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_CUSTOMER_REGISTER" msprop:Generator_TableClassName="DJK_CUSTOMER_REGISTERDataTable" msprop:Generator_TableVarName="tableDJK_CUSTOMER_REGISTER" msprop:Generator_TablePropName="DJK_CUSTOMER_REGISTER" msprop:Generator_RowDeletingName="DJK_CUSTOMER_REGISTERRowDeleting" msprop:Generator_RowChangingName="DJK_CUSTOMER_REGISTERRowChanging" msprop:Generator_RowEvHandlerName="DJK_CUSTOMER_REGISTERRowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_CUSTOMER_REGISTERRowDeleted" msprop:Generator_UserTableName="DJK_CUSTOMER_REGISTER" msprop:Generator_RowChangedName="DJK_CUSTOMER_REGISTERRowChanged" msprop:Generator_RowEvArgName="DJK_CUSTOMER_REGISTERRowChangeEvent" msprop:Generator_RowClassName="DJK_CUSTOMER_REGISTERRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CUSTOMER_REGISTER_ID" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_REGISTER_ID" msprop:Generator_ColumnPropNameInRow="CUSTOMER_REGISTER_ID" msprop:Generator_ColumnPropNameInTable="CUSTOMER_REGISTER_IDColumn" msprop:Generator_UserColumnName="CUSTOMER_REGISTER_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_REGISTER_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_REGISTER_ACCOUNT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_REGISTER_ACCOUNT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_REGISTER_ACCOUNTColumn" msprop:Generator_UserColumnName="CUSTOMER_REGISTER_ACCOUNT">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_REGISTER_PWD" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_REGISTER_PWD" msprop:Generator_ColumnPropNameInRow="CUSTOMER_REGISTER_PWD" msprop:Generator_ColumnPropNameInTable="CUSTOMER_REGISTER_PWDColumn" msprop:Generator_UserColumnName="CUSTOMER_REGISTER_PWD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_REGISTER_TIME" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_REGISTER_TIME" msprop:Generator_ColumnPropNameInRow="CUSTOMER_REGISTER_TIME" msprop:Generator_ColumnPropNameInTable="CUSTOMER_REGISTER_TIMEColumn" msprop:Generator_UserColumnName="CUSTOMER_REGISTER_TIME" type="xs:dateTime" />
              <xs:element name="CUSTOMER_ACCOUNT_TYPE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_ACCOUNT_TYPE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_ACCOUNT_TYPE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_ACCOUNT_TYPEColumn" msprop:Generator_UserColumnName="CUSTOMER_ACCOUNT_TYPE" type="xs:int" />
              <xs:element name="CUSTOMER_NICK" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_NICK" msprop:Generator_ColumnPropNameInRow="CUSTOMER_NICK" msprop:Generator_ColumnPropNameInTable="CUSTOMER_NICKColumn" msprop:Generator_UserColumnName="CUSTOMER_NICK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_CLIENT_CODE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CLIENT_CODE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CLIENT_CODE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CLIENT_CODEColumn" msprop:Generator_UserColumnName="CUSTOMER_CLIENT_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_USING_STATUS" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_USING_STATUS" msprop:Generator_ColumnPropNameInRow="ACCOUNT_USING_STATUS" msprop:Generator_ColumnPropNameInTable="ACCOUNT_USING_STATUSColumn" msprop:Generator_UserColumnName="ACCOUNT_USING_STATUS" type="xs:int" />
              <xs:element name="ACCOUNT_LOGIN_STATUS" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_LOGIN_STATUS" msprop:Generator_ColumnPropNameInRow="ACCOUNT_LOGIN_STATUS" msprop:Generator_ColumnPropNameInTable="ACCOUNT_LOGIN_STATUSColumn" msprop:Generator_UserColumnName="ACCOUNT_LOGIN_STATUS" type="xs:int" />
              <xs:element name="CUSTOMER_DEFAULT_PIC" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_DEFAULT_PIC" msprop:Generator_ColumnPropNameInRow="CUSTOMER_DEFAULT_PIC" msprop:Generator_ColumnPropNameInTable="CUSTOMER_DEFAULT_PICColumn" msprop:Generator_UserColumnName="CUSTOMER_DEFAULT_PIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_SOURCE_PIC" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_SOURCE_PIC" msprop:Generator_ColumnPropNameInRow="CUSTOMER_SOURCE_PIC" msprop:Generator_ColumnPropNameInTable="CUSTOMER_SOURCE_PICColumn" msprop:Generator_UserColumnName="CUSTOMER_SOURCE_PIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_ACTIVATION_CODE" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_ACTIVATION_CODE" msprop:Generator_ColumnPropNameInRow="ACCOUNT_ACTIVATION_CODE" msprop:Generator_ColumnPropNameInTable="ACCOUNT_ACTIVATION_CODEColumn" msprop:Generator_UserColumnName="ACCOUNT_ACTIVATION_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_IS_ACTIVATED" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_IS_ACTIVATED" msprop:Generator_ColumnPropNameInRow="ACCOUNT_IS_ACTIVATED" msprop:Generator_ColumnPropNameInTable="ACCOUNT_IS_ACTIVATEDColumn" msprop:Generator_UserColumnName="ACCOUNT_IS_ACTIVATED" type="xs:boolean" />
              <xs:element name="BE_INVITATION_CODE" msprop:Generator_ColumnVarNameInTable="columnBE_INVITATION_CODE" msprop:Generator_ColumnPropNameInRow="BE_INVITATION_CODE" msprop:Generator_ColumnPropNameInTable="BE_INVITATION_CODEColumn" msprop:Generator_UserColumnName="BE_INVITATION_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_INVITATION_CODE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_INVITATION_CODE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_INVITATION_CODE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_INVITATION_CODEColumn" msprop:Generator_UserColumnName="CUSTOMER_INVITATION_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_REGISTER_IP" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_REGISTER_IP" msprop:Generator_ColumnPropNameInRow="ACCOUNT_REGISTER_IP" msprop:Generator_ColumnPropNameInTable="ACCOUNT_REGISTER_IPColumn" msprop:Generator_UserColumnName="ACCOUNT_REGISTER_IP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_IS_DELETED" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_IS_DELETED" msprop:Generator_ColumnPropNameInRow="ACCOUNT_IS_DELETED" msprop:Generator_ColumnPropNameInTable="ACCOUNT_IS_DELETEDColumn" msprop:Generator_UserColumnName="ACCOUNT_IS_DELETED" type="xs:boolean" />
              <xs:element name="CUSTOMER_ACCOUNT_RMK" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_ACCOUNT_RMK" msprop:Generator_ColumnPropNameInRow="CUSTOMER_ACCOUNT_RMK" msprop:Generator_ColumnPropNameInTable="CUSTOMER_ACCOUNT_RMKColumn" msprop:Generator_UserColumnName="CUSTOMER_ACCOUNT_RMK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="INITIAL_DT" msprop:Generator_ColumnVarNameInTable="columnINITIAL_DT" msprop:Generator_ColumnPropNameInRow="INITIAL_DT" msprop:Generator_ColumnPropNameInTable="INITIAL_DTColumn" msprop:Generator_UserColumnName="INITIAL_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="INITIAL_USR" msprop:Generator_ColumnVarNameInTable="columnINITIAL_USR" msprop:Generator_ColumnPropNameInRow="INITIAL_USR" msprop:Generator_ColumnPropNameInTable="INITIAL_USRColumn" msprop:Generator_UserColumnName="INITIAL_USR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_PAY_INNERPWD" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_PAY_INNERPWD" msprop:Generator_ColumnPropNameInRow="CUSTOMER_PAY_INNERPWD" msprop:Generator_ColumnPropNameInTable="CUSTOMER_PAY_INNERPWDColumn" msprop:Generator_UserColumnName="CUSTOMER_PAY_INNERPWD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_SET_INNERPWDDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_SET_INNERPWDDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_SET_INNERPWDDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_SET_INNERPWDDTColumn" msprop:Generator_UserColumnName="CUSTOMER_SET_INNERPWDDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_LAST_MDINNERPWDDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_LAST_MDINNERPWDDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_LAST_MDINNERPWDDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_LAST_MDINNERPWDDTColumn" msprop:Generator_UserColumnName="CUSTOMER_LAST_MDINNERPWDDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="REG_VALID_CODE" msprop:Generator_ColumnVarNameInTable="columnREG_VALID_CODE" msprop:Generator_ColumnPropNameInRow="REG_VALID_CODE" msprop:Generator_ColumnPropNameInTable="REG_VALID_CODEColumn" msprop:Generator_UserColumnName="REG_VALID_CODE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALID_CREATE_DT" msprop:Generator_ColumnVarNameInTable="columnVALID_CREATE_DT" msprop:Generator_ColumnPropNameInRow="VALID_CREATE_DT" msprop:Generator_ColumnPropNameInTable="VALID_CREATE_DTColumn" msprop:Generator_UserColumnName="VALID_CREATE_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PWD_IS_MODIFIED" msprop:Generator_ColumnVarNameInTable="columnPWD_IS_MODIFIED" msprop:Generator_ColumnPropNameInRow="PWD_IS_MODIFIED" msprop:Generator_ColumnPropNameInTable="PWD_IS_MODIFIEDColumn" msprop:Generator_UserColumnName="PWD_IS_MODIFIED" type="xs:boolean" minOccurs="0" />
              <xs:element name="FIRST_USE_DT" msprop:Generator_ColumnVarNameInTable="columnFIRST_USE_DT" msprop:Generator_ColumnPropNameInRow="FIRST_USE_DT" msprop:Generator_ColumnPropNameInTable="FIRST_USE_DTColumn" msprop:Generator_UserColumnName="FIRST_USE_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FACCOUNT_ID" msprop:Generator_ColumnVarNameInTable="columnFACCOUNT_ID" msprop:Generator_ColumnPropNameInRow="FACCOUNT_ID" msprop:Generator_ColumnPropNameInTable="FACCOUNT_IDColumn" msprop:Generator_UserColumnName="FACCOUNT_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_GROUP_ID" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_GROUP_ID" msprop:Generator_ColumnPropNameInRow="ACCOUNT_GROUP_ID" msprop:Generator_ColumnPropNameInTable="ACCOUNT_GROUP_IDColumn" msprop:Generator_UserColumnName="ACCOUNT_GROUP_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REGISTER_BY_INNER" msprop:Generator_ColumnVarNameInTable="columnREGISTER_BY_INNER" msprop:Generator_ColumnPropNameInRow="REGISTER_BY_INNER" msprop:Generator_ColumnPropNameInTable="REGISTER_BY_INNERColumn" msprop:Generator_UserColumnName="REGISTER_BY_INNER" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_CUSTOMER_REGISTER" />
      <xs:field xpath="mstns:CUSTOMER_REGISTER_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>